Dataset info
| Number of variables | 82 |
|---|---|
| Number of observations | 90454 |
| Missing cells | 844516 (11.4%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 203.2 MiB |
| Average record size in memory | 2.3 KiB |
Variables types
| CAT | 46 |
|---|---|
| NUM | 19 |
| BOOL | 16 |
| DATE | 1 |
Reproduction info
| Date of analysis | 2020-05-27 04:48:04.534707 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
Alternative_purchasing_group has 3423 (3.8%) missing values | Missing |
Alternative_purchasing_group has a high cardinality: 560 distinct values | Warning |
ATC has a high cardinality: 1109 distinct values | Warning |
Chemical_/_biological has 7502 (8.3%) missing values | Missing |
consumption has 7507 (8.3%) zeros | Zeros |
consumption_previous_year has a high cardinality: 2746 distinct values | Warning |
Current_consumption has 8473 (9.4%) zeros | Zeros |
Dangerous_material_is_charged_with_a_permit has 80243 (88.7%) missing values | Missing |
dangerous_substance has 80259 (88.7%) missing values | Missing |
Date_of_basket_entry has 40977 (45.3%) missing values | Missing |
Date_of_basket_entry has a high cardinality: 54 distinct values | Warning |
Description_Alternative_purchasing_group has 3423 (3.8%) missing values | Missing |
Description_Alternative_purchasing_group has a high cardinality: 560 distinct values | Warning |
Description_outline has 6729 (7.4%) missing values | Missing |
Description_outline has a high cardinality: 306 distinct values | Warning |
Description_outline_Binary has 6729 (7.4%) missing values | Missing |
European_patent_expires has 89166 (98.6%) missing values | Missing |
For_adults has 86594 (95.7%) missing values | Missing |
Form_of_giving has 52783 (58.4%) missing values | Missing |
GENERY_FATHER has 53625 (59.3%) missing values | Missing |
GENERY_FATHER has a high cardinality: 678 distinct values | Warning |
Inventory has 10341 (11.4%) zeros | Zeros |
Inventory_of_consumption_months is highly skewed (γ1 = 82.16846137) | Skewed |
Inventory_of_consumption_months has 32842 (36.3%) zeros | Zeros |
Main_outline has 6729 (7.4%) missing values | Missing |
Main_outline has a high cardinality: 306 distinct values | Warning |
Narcotic_/_psychotropic has 41151 (45.5%) missing values | Missing |
Plant has constant value "7350.0" | Rejected |
Prediction has 8927 (9.9%) zeros | Zeros |
Price_for_absolute_packaging has 1275 (1.4%) zeros | Zeros |
Quantity_in_absolute_packaging has a high cardinality: 54 distinct values | Warning |
Quantity_in_Packaging-Absolute has 1275 (1.4%) zeros | Zeros |
Quantity_in_packing-relative has 64593 (71.4%) zeros | Zeros |
Safety_Stock has 9495 (10.5%) zeros | Zeros |
Send_code_to_Omri has constant value "1.0" | Rejected |
Serving_form has 7785 (8.6%) missing values | Missing |
Serving_form has a high cardinality: 53 distinct values | Warning |
Serving_form_Binary has 7785 (8.6%) missing values | Missing |
skucode2 has a high cardinality: 3197 distinct values | Warning |
status has constant value "1.0" | Rejected |
Toxic_item has 7200 (8.0%) missing values | Missing |
type_of_packeging has 85083 (94.1%) missing values | Missing |
U#S#_Patent_Expires has 88923 (98.3%) missing values | Missing |
Validity_of_Ministry_of_Health_registration has 85912 (95.0%) missing values | Missing |
Validity_of_Ministry_of_Health_registration has a high cardinality: 83 distinct values | Warning |
VENDOR has a high cardinality: 150 distinct values | Warning |
Material_Type_bool is highly correlated with A_group_of_materials and 1 other fields | High Correlation |
A_group_of_materials is highly correlated with Material_Type_bool | High Correlation |
other_Budget is highly correlated with Material_Type_bool | High Correlation |
PAC is highly correlated with EA | High Correlation |
EA is highly correlated with PAC | High Correlation |
Prediction is highly correlated with consumption and 1 other fields | High Correlation |
consumption is highly correlated with Prediction and 1 other fields | High Correlation |
Safety_Stock is highly correlated with consumption and 2 other fields | High Correlation |
Inventory is highly correlated with Safety_Stock | High Correlation |
General_purpose_ is highly correlated with General_purpose | High Correlation |
General_purpose is highly correlated with General_purpose_ | High Correlation |
month_year_ is highly correlated with month_year | High Correlation |
month_year is highly correlated with month_year_ | High Correlation |
Send_code_to_Omri is highly correlated with Plant and 1 other fields | High Correlation |
Plant is highly correlated with Send_code_to_Omri and 1 other fields | High Correlation |
status is highly correlated with Plant and 1 other fields | High Correlation |
A
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 88.5 KiB |
| 0 | |
|---|---|
| 1 | 10878 |
| Value | Count | Frequency (%) | |
| 0 | 79576 | 88.0% | |
| 1 | 10878 | 12.0% |
A_Budget
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 88.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 71746 | 79.3% | |
| 1 | 18708 | 20.7% |
| Distinct count | 37 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19411.27166 |
|---|---|
| Minimum | 1000 |
| Maximum | 20400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 353.5 KiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 10170 |
| Q1 | 20120 |
| median | 20160 |
| Q3 | 20190 |
| 95-th percentile | 20271 |
| Maximum | 20400 |
| Range | 19400 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 2688.875021 |
|---|---|
| Coefficient of variation (CV) | 0.1385213224 |
| Kurtosis | 10.00287005 |
| Mean | 19411.27166 |
| Median Absolute Deviation (MAD) | 1403.458419 |
| Skewness | -3.361444751 |
| Sum | 1755827167 |
| Variance | 7230048.879 |
| Value | Count | Frequency (%) | |
| 20190 | 14723 | 16.3% | |
| 20100 | 11235 | 12.4% | |
| 20120 | 9449 | 10.4% | |
| 20130 | 7744 | 8.6% | |
| 20210 | 5920 | 6.5% | |
| 20140 | 5192 | 5.7% | |
| 20270 | 4324 | 4.8% | |
| 20220 | 3800 | 4.2% | |
| 20180 | 3707 | 4.1% | |
| 20110 | 3031 | 3.4% | |
| Other values (27) | 21329 | 23.6% |
| Value | Count | Frequency (%) | |
| 1000 | 112 | 0.1% | |
| 2000 | 2 | < 0.1% | |
| 10100 | 739 | 0.8% | |
| 10120 | 5 | < 0.1% | |
| 10140 | 18 | < 0.1% |
| Value | Count | Frequency (%) | |
| 20400 | 75 | 0.1% | |
| 20276 | 799 | 0.9% | |
| 20275 | 9 | < 0.1% | |
| 20274 | 75 | 0.1% | |
| 20273 | 1389 | 1.5% |
A_group_of_materials_Binary
Real number (ℝ≥0)
| Distinct count | 36 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.918482651 |
|---|---|
| Minimum | 0.002205144602 |
| Maximum | 16.23317199 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0.002205144602 |
|---|---|
| 5-th percentile | 1.223855254 |
| Q1 | 3.341896645 |
| median | 6.527228023 |
| Q3 | 12.3873998 |
| 95-th percentile | 16.23317199 |
| Maximum | 16.23317199 |
| Range | 16.23096685 |
| Interquartile range (IQR) | 9.045503159 |
Descriptive statistics
| Standard deviation | 5.053374404 |
|---|---|
| Coefficient of variation (CV) | 0.638174588 |
| Kurtosis | -1.171548135 |
| Mean | 7.918482651 |
| Median Absolute Deviation (MAD) | 4.445250798 |
| Skewness | 0.3483673692 |
| Sum | 716258.4297 |
| Variance | 25.53659286 |
| Value | Count | Frequency (%) | |
| 16.23317199 | 14723 | 16.3% | |
| 12.3873998 | 11235 | 12.4% | |
| 10.41820567 | 9449 | 10.4% | |
| 8.5383199 | 7744 | 8.6% | |
| 6.527228023 | 5920 | 6.5% | |
| 5.724555388 | 5192 | 5.7% | |
| 4.76752263 | 4324 | 4.8% | |
| 4.189774744 | 3800 | 4.2% | |
| 4.08723552 | 3707 | 4.1% | |
| 3.341896645 | 3031 | 3.4% | |
| Other values (26) | 21329 | 23.6% |
| Value | Count | Frequency (%) | |
| 0.002205144602 | 2 | < 0.1% | |
| 0.005512861506 | 5 | < 0.1% | |
| 0.008820578409 | 8 | < 0.1% | |
| 0.009923150711 | 9 | < 0.1% | |
| 0.01874372912 | 17 | < 0.1% |
| Value | Count | Frequency (%) | |
| 16.23317199 | 14723 | 16.3% | |
| 12.3873998 | 11235 | 12.4% | |
| 10.41820567 | 9449 | 10.4% | |
| 8.5383199 | 7744 | 8.6% | |
| 6.527228023 | 5920 | 6.5% |
ABC
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| C | |
|---|---|
| B | |
| A |
| Value | Count | Frequency (%) | |
| C | 49305 | 54.5% | |
| B | 30271 | 33.5% | |
| A | 10878 | 12.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
Affiliation_Group
Categorical
| Distinct count | 35 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 147 |
| Missing (%) | 0.2% |
| Memory size | 706.8 KiB |
| 20 | |
|---|---|
| 11 | |
| 13 | |
| 24 | |
| 14 | |
| Other values (29) |
| Value | Count | Frequency (%) | |
| 20 | 14504 | 16.0% | |
| 11 | 11556 | 12.8% | |
| 13 | 9668 | 10.7% | |
| 24 | 9056 | 10.0% | |
| 14 | 8010 | 8.9% | |
| 21 | 6052 | 6.7% | |
| 15 | 5254 | 5.8% | |
| 22 | 4072 | 4.5% | |
| 19 | 3955 | 4.4% | |
| 17 | 2889 | 3.2% | |
| Other values (24) | 15291 | 16.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.003250271 |
| Min length | 2 |
Affiliation_Group_Binary
Real number (ℝ≥0)
| Distinct count | 34 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 147 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.716184966 |
|---|---|
| Minimum | 0.005521811154 |
| Maximum | 16.0176698 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0.005521811154 |
|---|---|
| 5-th percentile | 1.080066262 |
| Q1 | 4.496963004 |
| median | 8.845941469 |
| Q3 | 12.76200994 |
| 95-th percentile | 16.0176698 |
| Maximum | 16.0176698 |
| Range | 16.01214798 |
| Interquartile range (IQR) | 8.265046935 |
Descriptive statistics
| Standard deviation | 4.804353556 |
|---|---|
| Coefficient of variation (CV) | 0.5511991284 |
| Kurtosis | -1.114125492 |
| Mean | 8.716184966 |
| Median Absolute Deviation (MAD) | 4.099280616 |
| Skewness | -0.02999692185 |
| Sum | 787132.5157 |
| Variance | 23.08181309 |
| Value | Count | Frequency (%) | |
| 16.0176698 | 14504 | 16.0% | |
| 12.76200994 | 11556 | 12.8% | |
| 10.67697405 | 9668 | 10.7% | |
| 10.0905577 | 9056 | 10.0% | |
| 8.845941469 | 8010 | 8.9% | |
| 6.683600221 | 6052 | 6.7% | |
| 5.802319161 | 5254 | 5.8% | |
| 4.496963004 | 4072 | 4.5% | |
| 4.367752623 | 3955 | 4.4% | |
| 3.190502485 | 2889 | 3.2% | |
| Other values (23) | 15291 | 16.9% |
| Value | Count | Frequency (%) | |
| 0.005521811154 | 5 | < 0.1% | |
| 0.006626173385 | 6 | < 0.1% | |
| 0.007730535616 | 7 | < 0.1% | |
| 0.01214798454 | 11 | < 0.1% | |
| 0.02319160685 | 42 | < 0.1% |
| Value | Count | Frequency (%) | |
| 16.0176698 | 14504 | 16.0% | |
| 12.76200994 | 11556 | 12.8% | |
| 10.67697405 | 9668 | 10.7% | |
| 10.0905577 | 9056 | 10.0% | |
| 8.845941469 | 8010 | 8.9% |
| Distinct count | 560 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 3423 |
| Missing (%) | 3.8% |
| Memory size | 706.8 KiB |
| 1734 | 2963 |
|---|---|
| 1591 | 1889 |
| 1875 | 1705 |
| 1068 | 1515 |
| 1823 | 1352 |
| Other values (554) |
| Value | Count | Frequency (%) | |
| 1734 | 2963 | 3.3% | |
| 1591 | 1889 | 2.1% | |
| 1875 | 1705 | 1.9% | |
| 1068 | 1515 | 1.7% | |
| 1823 | 1352 | 1.5% | |
| 1317 | 1309 | 1.4% | |
| 1053 | 1217 | 1.3% | |
| 1642 | 1027 | 1.1% | |
| 1027 | 965 | 1.1% | |
| 1354 | 952 | 1.1% | |
| Other values (549) | 72137 | 79.7% | |
| (Missing) | 3423 | 3.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Distinct count | 1109 |
|---|---|
| Unique (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 1/0/1900 | 6595 |
|---|---|
| ATC: | 1096 |
| ATC:M01AE01 | 887 |
| ATC:C10AA07 | 631 |
| ATC:C10AA05 | 622 |
| Other values (1104) |
| Value | Count | Frequency (%) | |
| 1/0/1900 | 6595 | 7.3% | |
| ATC: | 1096 | 1.2% | |
| ATC:M01AE01 | 887 | 1.0% | |
| ATC:C10AA07 | 631 | 0.7% | |
| ATC:C10AA05 | 622 | 0.7% | |
| ATC:N03AX16 | 618 | 0.7% | |
| ATC:A11AA06 | 611 | 0.7% | |
| ATC:N06BA04 | 587 | 0.6% | |
| ATC:A11CC05 | 545 | 0.6% | |
| ATC:A07FA01 | 531 | 0.6% | |
| Other values (1099) | 77731 | 85.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 11 |
|---|---|
| Mean length | 10.53546554 |
| Min length | 4 |
B
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 88.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 60183 | 66.5% | |
| 1 | 30271 | 33.5% |
B_Budget
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 88.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 47212 | 52.2% | |
| 1 | 43242 | 47.8% |
Basic_unit_of_measure
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| EA | |
|---|---|
| PAC | 14317 |
| other_unit | 367 |
| Value | Count | Frequency (%) | |
| EA | 75770 | 83.8% | |
| PAC | 14317 | 15.8% | |
| other_unit | 367 | 0.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 10 |
|---|---|
| Mean length | 2.190737834 |
| Min length | 2 |
Budget_Group
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| B_Budget | |
|---|---|
| E_Budget | |
| A_Budget | |
| other_Budget | 5520 |
| Value | Count | Frequency (%) | |
| B_Budget | 43242 | 47.8% | |
| E_Budget | 22984 | 25.4% | |
| A_Budget | 18708 | 20.7% | |
| other_Budget | 5520 | 6.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 12 |
|---|---|
| Mean length | 8.244101974 |
| Min length | 8 |
C
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 88.5 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 49305 | 54.5% | |
| 0 | 41149 | 45.5% |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 7502 |
| Missing (%) | 8.3% |
| Memory size | 706.8 KiB |
| 1 | |
|---|---|
| 2 | 2981 |
| Value | Count | Frequency (%) | |
| 1 | 79971 | 88.4% | |
| 2 | 2981 | 3.3% | |
| (Missing) | 7502 | 8.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
chronic
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 376 |
| Missing (%) | 0.4% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 51001 | 56.4% | |
| 1 | 39077 | 43.2% | |
| (Missing) | 376 | 0.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
Consumer_management
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 706.8 KiB |
| ave | |
|---|---|
| pred |
| Value | Count | Frequency (%) | |
| ave | 74755 | 82.6% | |
| pred | 15698 | 17.4% | |
| (Missing) | 1 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.17355783 |
| Min length | 3 |
Consumer_management_Bool
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 706.8 KiB |
| 1 | |
|---|---|
| 0 | |
| (Missing) | 1 |
| Value | Count | Frequency (%) | |
| 1 | 74755 | 82.6% | |
| 0 | 15698 | 17.4% | |
| (Missing) | 1 | < 0.1% |
| Distinct count | 2220 |
|---|---|
| Unique (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.281552312 |
|---|---|
| Minimum | 0 |
| Maximum | 15.29536379 |
| Zeros | 7507 |
| Zeros (%) | 8.3% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6.728628613 |
| median | 8.459775921 |
| Q3 | 10.7676636 |
| 95-th percentile | 12.84698135 |
| Maximum | 15.29536379 |
| Range | 15.29536379 |
| Interquartile range (IQR) | 4.039034987 |
Descriptive statistics
| Standard deviation | 3.382993285 |
|---|---|
| Coefficient of variation (CV) | 0.4084974842 |
| Kurtosis | 0.6729187976 |
| Mean | 8.281552312 |
| Median Absolute Deviation (MAD) | 2.572532036 |
| Skewness | -0.8801192763 |
| Sum | 749099.5328 |
| Variance | 11.44464356 |
| Value | Count | Frequency (%) | |
| 0 | 7507 | 8.3% | |
| 6.933423026 | 133 | 0.1% | |
| 7.001245622 | 126 | 0.1% | |
| 5.953243334 | 121 | 0.1% | |
| 10.21431226 | 120 | 0.1% | |
| 7.794823152 | 118 | 0.1% | |
| 8.646289765 | 117 | 0.1% | |
| 6.520621128 | 116 | 0.1% | |
| 11.82188701 | 113 | 0.1% | |
| 7.071573364 | 110 | 0.1% | |
| Other values (2210) | 81873 | 90.5% |
| Value | Count | Frequency (%) | |
| 0 | 7507 | 8.3% | |
| 0.6931471806 | 25 | < 0.1% | |
| 1.098612289 | 20 | < 0.1% | |
| 1.386294361 | 16 | < 0.1% | |
| 1.791759469 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15.29536379 | 60 | 0.1% | |
| 15.01487305 | 60 | 0.1% | |
| 14.99096382 | 60 | 0.1% | |
| 14.30600347 | 60 | 0.1% | |
| 14.2794653 | 60 | 0.1% |
| Distinct count | 2746 |
|---|---|
| Unique (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 0 | 3745 |
|---|---|
| 12687 | 106 |
| 9622 | 94 |
| 11371 | 87 |
| 17716 | 83 |
| Other values (2741) |
| Value | Count | Frequency (%) | |
| 0 | 3745 | 4.1% | |
| 12687 | 106 | 0.1% | |
| 9622 | 94 | 0.1% | |
| 11371 | 87 | 0.1% | |
| 17716 | 83 | 0.1% | |
| 5770 | 83 | 0.1% | |
| 454770 | 79 | 0.1% | |
| 3530 | 70 | 0.1% | |
| 8341 | 62 | 0.1% | |
| 45662 | 60 | 0.1% | |
| Other values (2736) | 85985 | 95.1% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 7.278970526 |
| Min length | 3 |
| Distinct count | 2207 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 104264.5402 |
|---|---|
| Minimum | 0 |
| Maximum | 5666490 |
| Zeros | 8473 |
| Zeros (%) | 9.4% |
| Memory size | 353.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 977 |
| median | 5879 |
| Q3 | 64308 |
| 95-th percentile | 520530 |
| Maximum | 5666490 |
| Range | 5666490 |
| Interquartile range (IQR) | 63331 |
Descriptive statistics
| Standard deviation | 322775.2459 |
|---|---|
| Coefficient of variation (CV) | 3.095733653 |
| Kurtosis | 101.134983 |
| Mean | 104264.5402 |
| Median Absolute Deviation (MAD) | 144491.2226 |
| Skewness | 8.158516983 |
| Sum | 9431144720 |
| Variance | 1.041838594e+11 |
| Value | Count | Frequency (%) | |
| 0 | 8473 | 9.4% | |
| 3355 | 154 | 0.2% | |
| 120 | 151 | 0.2% | |
| 1023 | 147 | 0.2% | |
| 180 | 137 | 0.2% | |
| 602 | 134 | 0.1% | |
| 763 | 129 | 0.1% | |
| 722 | 119 | 0.1% | |
| 3814 | 118 | 0.1% | |
| 1401 | 117 | 0.1% | |
| Other values (2197) | 80775 | 89.3% |
| Value | Count | Frequency (%) | |
| 0 | 8473 | 9.4% | |
| 1 | 1 | < 0.1% | |
| 2 | 77 | 0.1% | |
| 3 | 26 | < 0.1% | |
| 4 | 10 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5666490 | 60 | 0.1% | |
| 4368000 | 60 | 0.1% | |
| 4218780 | 60 | 0.1% | |
| 2010420 | 60 | 0.1% | |
| 1938600 | 60 | 0.1% |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 80243 |
| Missing (%) | 88.7% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 1 | 205 |
| Value | Count | Frequency (%) | |
| 0 | 10006 | 11.1% | |
| 1 | 205 | 0.2% | |
| (Missing) | 80243 | 88.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.661341676 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 80259 |
| Missing (%) | 88.7% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 1 | 520 |
| Value | Count | Frequency (%) | |
| 0 | 9675 | 10.7% | |
| 1 | 520 | 0.6% | |
| (Missing) | 80259 | 88.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.661872333 |
| Min length | 1 |
| Distinct count | 54 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 40977 |
| Missing (%) | 45.3% |
| Memory size | 706.8 KiB |
| 01.01.1995 | |
|---|---|
| 01.01.2000 | 4298 |
| 01.03.2001 | 3326 |
| 01.03.1999 | 2760 |
| 01.03.2002 | 2118 |
| Other values (48) |
| Value | Count | Frequency (%) | |
| 01.01.1995 | 23781 | 26.3% | |
| 01.01.2000 | 4298 | 4.8% | |
| 01.03.2001 | 3326 | 3.7% | |
| 01.03.1999 | 2760 | 3.1% | |
| 01.03.2002 | 2118 | 2.3% | |
| 01.01.2009 | 1418 | 1.6% | |
| 01.05.2006 | 1402 | 1.5% | |
| 01.03.2008 | 1070 | 1.2% | |
| 15.01.2015 | 853 | 0.9% | |
| 01.01.2010 | 790 | 0.9% | |
| Other values (43) | 7661 | 8.5% | |
| (Missing) | 40977 | 45.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 7.281911248 |
| Min length | 4 |
| Distinct count | 560 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 3423 |
| Missing (%) | 3.8% |
| Memory size | 706.8 KiB |
| Hypertension | 2963 |
|---|---|
| Bact.Inf., Sys. | 1889 |
| Statines | 1705 |
| EPILEPSY- Anticonvulsants | 1515 |
| Pain, Mod/Sev | 1352 |
| Other values (554) |
| Value | Count | Frequency (%) | |
| Hypertension | 2963 | 3.3% | |
| Bact.Inf., Sys. | 1889 | 2.1% | |
| Statines | 1705 | 1.9% | |
| EPILEPSY- Anticonvulsants | 1515 | 1.7% | |
| Pain, Mod/Sev | 1352 | 1.5% | |
| הורדת חום ושיכוך כאב | 1309 | 1.4% | |
| Depression-SSRI | 1217 | 1.3% | |
| Diabetes Mell. | 1027 | 1.1% | |
| BPH | 965 | 1.1% | |
| טיפול אנטי פטרייתי | 952 | 1.1% | |
| Other values (549) | 72137 | 79.7% | |
| (Missing) | 3423 | 3.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 30 |
|---|---|
| Mean length | 15.2370155 |
| Min length | 2 |
| Distinct count | 306 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 6729 |
| Missing (%) | 7.4% |
| Memory size | 706.8 KiB |
| Hypertension | 3180 |
|---|---|
| Diabetes Mell. | 3005 |
| food adittive | 2471 |
| Not Designated | 2280 |
| Epilepsy | 2016 |
| Other values (300) |
| Value | Count | Frequency (%) | |
| Hypertension | 3180 | 3.5% | |
| Diabetes Mell. | 3005 | 3.3% | |
| food adittive | 2471 | 2.7% | |
| Not Designated | 2280 | 2.5% | |
| Epilepsy | 2016 | 2.2% | |
| Bact.Inf., Sys. | 1893 | 2.1% | |
| cosmetics | 1868 | 2.1% | |
| Statines | 1705 | 1.9% | |
| Antidepressants | 1683 | 1.9% | |
| Pain, Mild/Mod. | 1602 | 1.8% | |
| Other values (295) | 62022 | 68.6% | |
| (Missing) | 6729 | 7.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 30 |
|---|---|
| Mean length | 12.01320008 |
| Min length | 3 |
| Distinct count | 213 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 6729 |
| Missing (%) | 7.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.244544612 |
|---|---|
| Minimum | 0.001193231988 |
| Maximum | 3.794477722 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0.001193231988 |
|---|---|
| 5-th percentile | 0.09426532706 |
| Q1 | 0.404505644 |
| median | 0.8973104551 |
| Q3 | 1.911557645 |
| 95-th percentile | 3.585662124 |
| Maximum | 3.794477722 |
| Range | 3.79328449 |
| Interquartile range (IQR) | 1.507052001 |
Descriptive statistics
| Standard deviation | 1.050191326 |
|---|---|
| Coefficient of variation (CV) | 0.8438358222 |
| Kurtosis | -0.06892555453 |
| Mean | 1.244544612 |
| Median Absolute Deviation (MAD) | 0.8715220875 |
| Skewness | 0.9530542623 |
| Sum | 104199.4976 |
| Variance | 1.102901821 |
| Value | Count | Frequency (%) | |
| 3.794477722 | 3180 | 3.5% | |
| 3.585662124 | 3005 | 3.3% | |
| 2.948476243 | 2471 | 2.7% | |
| 2.817220724 | 2280 | 2.5% | |
| 2.405555688 | 2016 | 2.2% | |
| 2.258788154 | 1893 | 2.1% | |
| 2.228957354 | 1868 | 2.1% | |
| 2.03446054 | 1705 | 1.9% | |
| 2.008209436 | 1683 | 1.9% | |
| 1.911557645 | 1602 | 1.8% | |
| Other values (202) | 62022 | 68.6% | |
| (Missing) | 6729 | 7.4% |
| Value | Count | Frequency (%) | |
| 0.001193231988 | 10 | < 0.1% | |
| 0.002386463976 | 10 | < 0.1% | |
| 0.003579695964 | 15 | < 0.1% | |
| 0.004772927953 | 8 | < 0.1% | |
| 0.005966159941 | 15 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3.794477722 | 3180 | 3.5% | |
| 3.585662124 | 3005 | 3.3% | |
| 2.948476243 | 2471 | 2.7% | |
| 2.817220724 | 2280 | 2.5% | |
| 2.405555688 | 2016 | 2.2% |
| Distinct count | 90454 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54598.84563 |
|---|---|
| Minimum | 0 |
| Maximum | 109199 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5448.65 |
| Q1 | 27270.5 |
| median | 54644.5 |
| Q3 | 81873.75 |
| 95-th percentile | 103720.35 |
| Maximum | 109199 |
| Range | 109199 |
| Interquartile range (IQR) | 54603.25 |
Descriptive statistics
| Standard deviation | 31522.28374 |
|---|---|
| Coefficient of variation (CV) | 0.5773434103 |
| Kurtosis | -1.200205829 |
| Mean | 54598.84563 |
| Median Absolute Deviation (MAD) | 27302.9025 |
| Skewness | -0.0008364606841 |
| Sum | 4938683983 |
| Variance | 993654372 |
| Value | Count | Frequency (%) | |
| 6141 | 1 | < 0.1% | |
| 70455 | 1 | < 0.1% | |
| 25305 | 1 | < 0.1% | |
| 31450 | 1 | < 0.1% | |
| 29403 | 1 | < 0.1% | |
| 19164 | 1 | < 0.1% | |
| 17117 | 1 | < 0.1% | |
| 23262 | 1 | < 0.1% | |
| 21215 | 1 | < 0.1% | |
| 107233 | 1 | < 0.1% | |
| Other values (90444) | 90444 | > 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 109199 | 1 | < 0.1% | |
| 109198 | 1 | < 0.1% | |
| 109197 | 1 | < 0.1% | |
| 109196 | 1 | < 0.1% | |
| 109195 | 1 | < 0.1% |
E_Budget
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 88.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 67470 | 74.6% | |
| 1 | 22984 | 25.4% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 88.5 KiB |
| 1 | |
|---|---|
| 0 | 14684 |
| Value | Count | Frequency (%) | |
| 1 | 75770 | 83.8% | |
| 0 | 14684 | 16.2% |
| Distinct count | 874 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| Minimum | 2006-03-06 00:00:00 |
|---|---|
| Maximum | 2019-08-19 00:00:00 |
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 89166 |
| Missing (%) | 98.6% |
| Memory size | 706.8 KiB |
| 01.02.2015 | |
|---|---|
| 01.06.2017 | 99 |
| 01.03.2016 | 98 |
| 01.10.2018 | 96 |
| 01.03.2017 | 81 |
| Other values (24) |
| Value | Count | Frequency (%) | |
| 01.02.2015 | 168 | 0.2% | |
| 01.06.2017 | 99 | 0.1% | |
| 01.03.2016 | 98 | 0.1% | |
| 01.10.2018 | 96 | 0.1% | |
| 01.03.2017 | 81 | 0.1% | |
| 01.09.2019 | 65 | 0.1% | |
| 01.12.2022 | 61 | 0.1% | |
| 01.05.2020 | 60 | 0.1% | |
| 01.07.2018 | 59 | 0.1% | |
| 01.05.2019 | 53 | 0.1% | |
| Other values (19) | 448 | 0.5% | |
| (Missing) | 89166 | 98.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.085435691 |
| Min length | 4 |
Exceptional_policy
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 1 | 9673 |
| Value | Count | Frequency (%) | |
| 0 | 80781 | 89.3% | |
| 1 | 9673 | 10.7% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 86594 |
| Missing (%) | 95.7% |
| Memory size | 706.8 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 3860 | 4.3% | |
| (Missing) | 86594 | 95.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.871979128 |
| Min length | 1 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 52783 |
| Missing (%) | 58.4% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 17 | 22 |
| 15 | 6 |
| Value | Count | Frequency (%) | |
| 0 | 37643 | 41.6% | |
| 17 | 22 | < 0.1% | |
| 15 | 6 | < 0.1% | |
| (Missing) | 52783 | 58.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.750912066 |
| Min length | 1 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 6 | 842 |
| 2 | 378 |
| 1 | 205 |
| Value | Count | Frequency (%) | |
| 0 | 89029 | 98.4% | |
| 6 | 842 | 0.9% | |
| 2 | 378 | 0.4% | |
| 1 | 205 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 6 | 842 |
| 2 | 378 |
| 1 | 205 |
| Value | Count | Frequency (%) | |
| 0 | 89029 | 98.4% | |
| 6 | 842 | 0.9% | |
| 2 | 378 | 0.4% | |
| 1 | 205 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 678 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 53625 |
| Missing (%) | 59.3% |
| Memory size | 706.8 KiB |
| 3999001541 | 186 |
|---|---|
| 3999001291 | 179 |
| 3999019172 | 178 |
| 3999001511 | 177 |
| 3999001491 | 176 |
| Other values (672) |
| Value | Count | Frequency (%) | |
| 3999001541 | 186 | 0.2% | |
| 3999001291 | 179 | 0.2% | |
| 3999019172 | 178 | 0.2% | |
| 3999001511 | 177 | 0.2% | |
| 3999001491 | 176 | 0.2% | |
| 3999001490 | 174 | 0.2% | |
| 3999001542 | 171 | 0.2% | |
| 3999001150 | 171 | 0.2% | |
| 3999003522 | 167 | 0.2% | |
| 3999001280 | 165 | 0.2% | |
| Other values (667) | 35085 | 38.8% | |
| (Missing) | 53625 | 59.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 10 |
|---|---|
| Mean length | 6.442943375 |
| Min length | 4 |
| Distinct count | 2247 |
|---|---|
| Unique (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.353178613 |
|---|---|
| Minimum | 0 |
| Maximum | 15.68157028 |
| Zeros | 10341 |
| Zeros (%) | 11.4% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7.139660336 |
| median | 8.65347081 |
| Q3 | 11.09560536 |
| 95-th percentile | 13.09956751 |
| Maximum | 15.68157028 |
| Range | 15.68157028 |
| Interquartile range (IQR) | 3.955945027 |
Descriptive statistics
| Standard deviation | 3.688092249 |
|---|---|
| Coefficient of variation (CV) | 0.4415196203 |
| Kurtosis | 0.5351412593 |
| Mean | 8.353178613 |
| Median Absolute Deviation (MAD) | 2.730679738 |
| Skewness | -0.982820625 |
| Sum | 755578.4183 |
| Variance | 13.60202444 |
| Value | Count | Frequency (%) | |
| 0 | 10341 | 11.4% | |
| 6.775366091 | 130 | 0.1% | |
| 5.993961427 | 120 | 0.1% | |
| 8.567696174 | 120 | 0.1% | |
| 8.802071337 | 120 | 0.1% | |
| 8.896588072 | 120 | 0.1% | |
| 7.700295203 | 117 | 0.1% | |
| 10.63135012 | 116 | 0.1% | |
| 11.21682136 | 115 | 0.1% | |
| 7.843064017 | 114 | 0.1% | |
| Other values (2237) | 79041 | 87.4% |
| Value | Count | Frequency (%) | |
| 0 | 10341 | 11.4% | |
| 1.098612289 | 8 | < 0.1% | |
| 1.791759469 | 59 | 0.1% | |
| 1.945910149 | 32 | < 0.1% | |
| 2.079441542 | 13 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15.68157028 | 60 | 0.1% | |
| 15.66207555 | 60 | 0.1% | |
| 15.09810996 | 60 | 0.1% | |
| 14.79540725 | 60 | 0.1% | |
| 14.71774334 | 60 | 0.1% |
| Distinct count | 32 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.324861255 |
|---|---|
| Minimum | 0 |
| Maximum | 786 |
| Zeros | 32842 |
| Zeros (%) | 36.3% |
| Memory size | 353.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 786 |
| Range | 786 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 7.41955628 |
|---|---|
| Coefficient of variation (CV) | 5.600251536 |
| Kurtosis | 8370.552844 |
| Mean | 1.324861255 |
| Median Absolute Deviation (MAD) | 1.184277666 |
| Skewness | 82.16846137 |
| Sum | 119839 |
| Variance | 55.0498154 |
| Value | Count | Frequency (%) | |
| 0 | 32842 | 36.3% | |
| 1 | 30937 | 34.2% | |
| 2 | 16365 | 18.1% | |
| 3 | 6827 | 7.5% | |
| 4 | 1739 | 1.9% | |
| 5 | 626 | 0.7% | |
| 6 | 244 | 0.3% | |
| 7 | 157 | 0.2% | |
| 8 | 121 | 0.1% | |
| 10 | 104 | 0.1% | |
| Other values (22) | 492 | 0.5% |
| Value | Count | Frequency (%) | |
| 0 | 32842 | 36.3% | |
| 1 | 30937 | 34.2% | |
| 2 | 16365 | 18.1% | |
| 3 | 6827 | 7.5% | |
| 4 | 1739 | 1.9% |
| Value | Count | Frequency (%) | |
| 786 | 6 | < 0.1% | |
| 255 | 2 | < 0.1% | |
| 145 | 18 | < 0.1% | |
| 109 | 15 | < 0.1% | |
| 98 | 21 | < 0.1% |
Item_in_health_basket
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 144 |
| Missing (%) | 0.2% |
| Memory size | 706.8 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 56289 | 62.2% | |
| 0 | 34021 | 37.6% | |
| (Missing) | 144 | 0.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
Item_Type
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 405 |
| Missing (%) | 0.4% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 1 | 252 |
| 6 | 60 |
| 3 | 60 |
| Value | Count | Frequency (%) | |
| 0 | 89677 | 99.1% | |
| 1 | 252 | 0.3% | |
| 6 | 60 | 0.1% | |
| 3 | 60 | 0.1% | |
| (Missing) | 405 | 0.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
Loading_group
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 23 | |
|---|---|
| 11 | 3303 |
| 25 | 2814 |
| 13 | 1700 |
| 24 | 1186 |
| Other values (7) | 2734 |
| Value | Count | Frequency (%) | |
| 23 | 78717 | 87.0% | |
| 11 | 3303 | 3.7% | |
| 25 | 2814 | 3.1% | |
| 13 | 1700 | 1.9% | |
| 24 | 1186 | 1.3% | |
| 12 | 839 | 0.9% | |
| 22 | 748 | 0.8% | |
| 15 | 471 | 0.5% | |
| 14 | 333 | 0.4% | |
| 19 | 206 | 0.2% | |
| Other values (2) | 137 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 2 |
|---|---|
| Mean length | 1.998540695 |
| Min length | 1 |
| Distinct count | 306 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 6729 |
| Missing (%) | 7.4% |
| Memory size | 706.8 KiB |
| 13 | 3180 |
|---|---|
| 12 | 3005 |
| 393 | 2471 |
| 0 | 2280 |
| 14 | 2016 |
| Other values (300) |
| Value | Count | Frequency (%) | |
| 13 | 3180 | 3.5% | |
| 12 | 3005 | 3.3% | |
| 393 | 2471 | 2.7% | |
| 0 | 2280 | 2.5% | |
| 14 | 2016 | 2.2% | |
| 60 | 1893 | 2.1% | |
| 392 | 1868 | 2.1% | |
| 432 | 1705 | 1.9% | |
| 420 | 1683 | 1.9% | |
| 54 | 1602 | 1.8% | |
| Other values (295) | 62022 | 68.6% | |
| (Missing) | 6729 | 7.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.557620448 |
| Min length | 1 |
Material_Type
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| ZHW1 | |
|---|---|
| ZHW3 | 6697 |
| Value | Count | Frequency (%) | |
| ZHW1 | 83757 | 92.6% | |
| ZHW3 | 6697 | 7.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 1 | |
|---|---|
| 0 | 6697 |
| Value | Count | Frequency (%) | |
| 1 | 83757 | 92.6% | |
| 0 | 6697 | 7.4% |
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 07/2018 | 3179 |
|---|---|
| 01/2019 | 3138 |
| 08/2018 | 3122 |
| 10/2018 | 3120 |
| 07/2019 | 3104 |
| Other values (25) |
| Value | Count | Frequency (%) | |
| 07/2018 | 3179 | 3.5% | |
| 01/2019 | 3138 | 3.5% | |
| 08/2018 | 3122 | 3.5% | |
| 10/2018 | 3120 | 3.4% | |
| 07/2019 | 3104 | 3.4% | |
| 01/2018 | 3098 | 3.4% | |
| 10/2017 | 3080 | 3.4% | |
| 05/2018 | 3079 | 3.4% | |
| 09/2019 | 3077 | 3.4% | |
| 03/2019 | 3072 | 3.4% | |
| Other values (20) | 59385 | 65.7% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 7 |
|---|---|
| Mean length | 7 |
| Min length | 7 |
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 07/2018 | 3179 |
|---|---|
| 01/2019 | 3138 |
| 08/2018 | 3122 |
| 10/2018 | 3120 |
| 07/2019 | 3104 |
| Other values (25) |
| Value | Count | Frequency (%) | |
| 07/2018 | 3179 | 3.5% | |
| 01/2019 | 3138 | 3.5% | |
| 08/2018 | 3122 | 3.5% | |
| 10/2018 | 3120 | 3.4% | |
| 07/2019 | 3104 | 3.4% | |
| 01/2018 | 3098 | 3.4% | |
| 10/2017 | 3080 | 3.4% | |
| 05/2018 | 3079 | 3.4% | |
| 09/2019 | 3077 | 3.4% | |
| 03/2019 | 3072 | 3.4% | |
| Other values (20) | 59385 | 65.7% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 7 |
|---|---|
| Mean length | 7 |
| Min length | 7 |
Must_prescribe
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 56 |
| Missing (%) | 0.1% |
| Memory size | 706.8 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 57404 | 63.5% | |
| 0 | 32994 | 36.5% | |
| (Missing) | 56 | 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 41151 |
| Missing (%) | 45.5% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 1 | 1700 |
| 2 | 839 |
| 3 | 391 |
| 5 | 96 |
| Value | Count | Frequency (%) | |
| 0 | 46277 | 51.2% | |
| 1 | 1700 | 1.9% | |
| 2 | 839 | 0.9% | |
| 3 | 391 | 0.4% | |
| 5 | 96 | 0.1% | |
| (Missing) | 41151 | 45.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 88.5 KiB |
| 0 | |
|---|---|
| 1 | 5520 |
| Value | Count | Frequency (%) | |
| 0 | 84934 | 93.9% | |
| 1 | 5520 | 6.1% |
other_unit
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 88.5 KiB |
| 0 | |
|---|---|
| 1 | 367 |
| Value | Count | Frequency (%) | |
| 0 | 90087 | 99.6% | |
| 1 | 367 | 0.4% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 88.5 KiB |
| 0 | |
|---|---|
| 1 | 14317 |
| Value | Count | Frequency (%) | |
| 0 | 76137 | 84.2% | |
| 1 | 14317 | 15.8% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 7350 |
|---|
| Value | Count | Frequency (%) | |
| 7350 | 90454 | 100.0% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Distinct count | 2160 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.144863463 |
|---|---|
| Minimum | 0 |
| Maximum | 15.27477258 |
| Zeros | 8927 |
| Zeros (%) | 9.9% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6.626717749 |
| median | 8.390949465 |
| Q3 | 10.73876344 |
| 95-th percentile | 12.80583454 |
| Maximum | 15.27477258 |
| Range | 15.27477258 |
| Interquartile range (IQR) | 4.112045688 |
Descriptive statistics
| Standard deviation | 3.508709916 |
|---|---|
| Coefficient of variation (CV) | 0.4307880583 |
| Kurtosis | 0.4730093702 |
| Mean | 8.144863463 |
| Median Absolute Deviation (MAD) | 2.669442736 |
| Skewness | -0.8707628432 |
| Sum | 736735.4797 |
| Variance | 12.31104528 |
| Value | Count | Frequency (%) | |
| 0 | 8927 | 9.9% | |
| 6.442540166 | 159 | 0.2% | |
| 6.144185634 | 141 | 0.2% | |
| 7.290974778 | 139 | 0.2% | |
| 7.166265974 | 137 | 0.2% | |
| 6.156978986 | 130 | 0.1% | |
| 6.395261598 | 125 | 0.1% | |
| 8.839856233 | 120 | 0.1% | |
| 11.40038367 | 120 | 0.1% | |
| 8.239065332 | 120 | 0.1% | |
| Other values (2150) | 80336 | 88.8% |
| Value | Count | Frequency (%) | |
| 0 | 8927 | 9.9% | |
| 0.6931471806 | 2 | < 0.1% | |
| 1.386294361 | 1 | < 0.1% | |
| 1.609437912 | 1 | < 0.1% | |
| 1.791759469 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15.27477258 | 60 | 0.1% | |
| 14.94489451 | 60 | 0.1% | |
| 14.8846961 | 60 | 0.1% | |
| 14.28658923 | 60 | 0.1% | |
| 14.25602938 | 60 | 0.1% |
PRICE
Real number (ℝ≥0)
| Distinct count | 1451 |
|---|---|
| Unique (%) | 1.6% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.855938488 |
|---|---|
| Minimum | 0.009950330853 |
| Maximum | 9.4809597 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0.009950330853 |
|---|---|
| 5-th percentile | 0.1310282624 |
| Q1 | 0.3920420878 |
| median | 1.757857918 |
| Q3 | 2.859339649 |
| 95-th percentile | 4.380149875 |
| Maximum | 9.4809597 |
| Range | 9.471009369 |
| Interquartile range (IQR) | 2.467297561 |
Descriptive statistics
| Standard deviation | 1.517936584 |
|---|---|
| Coefficient of variation (CV) | 0.8178808689 |
| Kurtosis | 0.8585050542 |
| Mean | 1.855938488 |
| Median Absolute Deviation (MAD) | 1.261593316 |
| Skewness | 0.8630418938 |
| Sum | 167869.6363 |
| Variance | 2.304131472 |
| Value | Count | Frequency (%) | |
| 0.1310282624 | 1143 | 1.3% | |
| 0.1484200051 | 893 | 1.0% | |
| 0.1397619424 | 881 | 1.0% | |
| 0.2851789422 | 873 | 1.0% | |
| 0.1823215568 | 862 | 1.0% | |
| 0.2546422184 | 854 | 0.9% | |
| 0.1043600153 | 846 | 0.9% | |
| 0.4121096508 | 762 | 0.8% | |
| 2.541601993 | 733 | 0.8% | |
| 0.0953101798 | 715 | 0.8% | |
| Other values (1440) | 81888 | 90.5% |
| Value | Count | Frequency (%) | |
| 0.009950330853 | 173 | 0.2% | |
| 0.02955880224 | 195 | 0.2% | |
| 0.03922071315 | 151 | 0.2% | |
| 0.04879016417 | 210 | 0.2% | |
| 0.05826890812 | 177 | 0.2% |
| Value | Count | Frequency (%) | |
| 9.4809597 | 1 | < 0.1% | |
| 9.431307156 | 28 | < 0.1% | |
| 9.256069666 | 4 | < 0.1% | |
| 9.145556487 | 5 | < 0.1% | |
| 9.015209525 | 2 | < 0.1% |
| Distinct count | 1843 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.39336019 |
|---|---|
| Minimum | 0 |
| Maximum | 10.8079154 |
| Zeros | 1275 |
| Zeros (%) | 1.4% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.16938136 |
| Q1 | 2.151762203 |
| median | 2.85532012 |
| Q3 | 4.282206299 |
| 95-th percentile | 7.335086244 |
| Maximum | 10.8079154 |
| Range | 10.8079154 |
| Interquartile range (IQR) | 2.130444096 |
Descriptive statistics
| Standard deviation | 1.856955119 |
|---|---|
| Coefficient of variation (CV) | 0.5472319516 |
| Kurtosis | 0.641286598 |
| Mean | 3.39336019 |
| Median Absolute Deviation (MAD) | 1.448362879 |
| Skewness | 0.9849268277 |
| Sum | 306929.4292 |
| Variance | 3.448282315 |
| Value | Count | Frequency (%) | |
| 0 | 1275 | 1.4% | |
| 1.757857918 | 1040 | 1.1% | |
| 1.648658626 | 922 | 1.0% | |
| 2.541601993 | 649 | 0.7% | |
| 2.791165108 | 635 | 0.7% | |
| 1.458615023 | 611 | 0.7% | |
| 2.272125886 | 599 | 0.7% | |
| 1.945910149 | 583 | 0.6% | |
| 1.902107526 | 481 | 0.5% | |
| 1.386294361 | 480 | 0.5% | |
| Other values (1832) | 83175 | 92.0% |
| Value | Count | Frequency (%) | |
| 0 | 1275 | 1.4% | |
| 0.02955880224 | 52 | 0.1% | |
| 0.06765864847 | 60 | 0.1% | |
| 0.08617769624 | 75 | 0.1% | |
| 0.0953101798 | 179 | 0.2% |
| Value | Count | Frequency (%) | |
| 10.8079154 | 4 | < 0.1% | |
| 10.62652188 | 1 | < 0.1% | |
| 10.46598376 | 5 | < 0.1% | |
| 10.32333606 | 1 | < 0.1% | |
| 10.20502815 | 7 | < 0.1% |
Pure_OTC
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 67149 | 74.2% | |
| 1 | 23305 | 25.8% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 54 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 1 | |
|---|---|
| 30 | |
| 28 | 6078 |
| 60 | 4679 |
| 20 | 4570 |
| Other values (49) |
| Value | Count | Frequency (%) | |
| 1 | 32147 | 35.5% | |
| 30 | 20321 | 22.5% | |
| 28 | 6078 | 6.7% | |
| 60 | 4679 | 5.2% | |
| 20 | 4570 | 5.1% | |
| 100 | 3030 | 3.3% | |
| 10 | 2182 | 2.4% | |
| 50 | 2030 | 2.2% | |
| 5 | 1623 | 1.8% | |
| 56 | 1516 | 1.7% | |
| Other values (44) | 12278 | 13.6% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 5 |
|---|---|
| Mean length | 3.613085104 |
| Min length | 3 |
| Distinct count | 54 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.19395494 |
|---|---|
| Minimum | 0 |
| Maximum | 448 |
| Zeros | 1275 |
| Zeros (%) | 1.4% |
| Memory size | 353.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 90 |
| Maximum | 448 |
| Range | 448 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 28.61399747 |
|---|---|
| Coefficient of variation (CV) | 1.233683412 |
| Kurtosis | 18.15022935 |
| Mean | 23.19395494 |
| Median Absolute Deviation (MAD) | 20.0623727 |
| Skewness | 2.832334298 |
| Sum | 2097986 |
| Variance | 818.760851 |
| Value | Count | Frequency (%) | |
| 1 | 32147 | 35.5% | |
| 30 | 20321 | 22.5% | |
| 28 | 6078 | 6.7% | |
| 60 | 4679 | 5.2% | |
| 20 | 4570 | 5.1% | |
| 100 | 3030 | 3.3% | |
| 10 | 2182 | 2.4% | |
| 50 | 2030 | 2.2% | |
| 5 | 1623 | 1.8% | |
| 56 | 1516 | 1.7% | |
| Other values (44) | 12278 | 13.6% |
| Value | Count | Frequency (%) | |
| 0 | 1275 | 1.4% | |
| 1 | 32147 | 35.5% | |
| 2 | 1026 | 1.1% | |
| 3 | 663 | 0.7% | |
| 4 | 1165 | 1.3% |
| Value | Count | Frequency (%) | |
| 448 | 1 | < 0.1% | |
| 400 | 36 | < 0.1% | |
| 270 | 3 | < 0.1% | |
| 224 | 3 | < 0.1% | |
| 210 | 30 | < 0.1% |
| Distinct count | 65 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.6325204 |
|---|---|
| Minimum | 0 |
| Maximum | 1000 |
| Zeros | 64593 |
| Zeros (%) | 71.4% |
| Memory size | 353.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 5 |
| 95-th percentile | 120 |
| Maximum | 1000 |
| Range | 1000 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 82.28814741 |
|---|---|
| Coefficient of variation (CV) | 3.340630438 |
| Kurtosis | 42.05369159 |
| Mean | 24.6325204 |
| Median Absolute Deviation (MAD) | 38.92203777 |
| Skewness | 5.695056527 |
| Sum | 2228110 |
| Variance | 6771.339204 |
| Value | Count | Frequency (%) | |
| 0 | 64593 | 71.4% | |
| 15 | 3022 | 3.3% | |
| 100 | 2266 | 2.5% | |
| 10 | 2085 | 2.3% | |
| 50 | 1960 | 2.2% | |
| 30 | 1905 | 2.1% | |
| 5 | 1510 | 1.7% | |
| 20 | 1174 | 1.3% | |
| 3 | 1057 | 1.2% | |
| 500 | 992 | 1.1% | |
| Other values (55) | 9890 | 10.9% |
| Value | Count | Frequency (%) | |
| 0 | 64593 | 71.4% | |
| 1 | 863 | 1.0% | |
| 2 | 803 | 0.9% | |
| 3 | 1057 | 1.2% | |
| 4 | 145 | 0.2% |
| Value | Count | Frequency (%) | |
| 1000 | 115 | 0.1% | |
| 750 | 58 | 0.1% | |
| 500 | 992 | 1.1% | |
| 454 | 51 | 0.1% | |
| 450 | 121 | 0.1% |
| Distinct count | 2126 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.921032659 |
|---|---|
| Minimum | 0 |
| Maximum | 15.47226784 |
| Zeros | 9495 |
| Zeros (%) | 10.5% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6.541029999 |
| median | 8.048149102 |
| Q3 | 10.62281404 |
| 95-th percentile | 12.59795594 |
| Maximum | 15.47226784 |
| Range | 15.47226784 |
| Interquartile range (IQR) | 4.081784046 |
Descriptive statistics
| Standard deviation | 3.495047017 |
|---|---|
| Coefficient of variation (CV) | 0.4412362842 |
| Kurtosis | 0.4302132916 |
| Mean | 7.921032659 |
| Median Absolute Deviation (MAD) | 2.632891965 |
| Skewness | -0.8280378059 |
| Sum | 716489.0882 |
| Variance | 12.21535365 |
| Value | Count | Frequency (%) | |
| 0 | 9495 | 10.5% | |
| 7.119635638 | 136 | 0.2% | |
| 7.239214974 | 130 | 0.1% | |
| 6.135564891 | 126 | 0.1% | |
| 6.602587892 | 122 | 0.1% | |
| 7.493873887 | 121 | 0.1% | |
| 10.8062066 | 120 | 0.1% | |
| 7.400009517 | 120 | 0.1% | |
| 11.87214417 | 119 | 0.1% | |
| 11.31568112 | 119 | 0.1% | |
| Other values (2116) | 79846 | 88.3% |
| Value | Count | Frequency (%) | |
| 0 | 9495 | 10.5% | |
| 0.6931471806 | 19 | < 0.1% | |
| 1.386294361 | 33 | < 0.1% | |
| 1.609437912 | 1 | < 0.1% | |
| 1.791759469 | 21 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15.47226784 | 60 | 0.1% | |
| 15.4438134 | 60 | 0.1% | |
| 15.00171636 | 60 | 0.1% | |
| 14.77718948 | 60 | 0.1% | |
| 14.633735 | 60 | 0.1% |
Seasonality
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 11 |
| Missing (%) | < 0.1% |
| Memory size | 706.8 KiB |
| no | |
|---|---|
| yes | 13949 |
| (Missing) | 11 |
| Value | Count | Frequency (%) | |
| no | 76494 | 84.6% | |
| yes | 13949 | 15.4% | |
| (Missing) | 11 | < 0.1% |
Seasonality_bool
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 11 |
| Missing (%) | < 0.1% |
| Memory size | 706.8 KiB |
| 1 | |
|---|---|
| 0 | 13949 |
| (Missing) | 11 |
| Value | Count | Frequency (%) | |
| 1 | 76494 | 84.6% | |
| 0 | 13949 | 15.4% | |
| (Missing) | 11 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 90454 | 100.0% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 53 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 7785 |
| Missing (%) | 8.6% |
| Memory size | 706.8 KiB |
| TAB | |
|---|---|
| CAP | |
| CR | 4923 |
| COL | 3135 |
| CPL | 2565 |
| Other values (47) |
| Value | Count | Frequency (%) | |
| TAB | 37094 | 41.0% | |
| CAP | 8375 | 9.3% | |
| CR | 4923 | 5.4% | |
| COL | 3135 | 3.5% | |
| CPL | 2565 | 2.8% | |
| GEL | 2051 | 2.3% | |
| OIN | 1977 | 2.2% | |
| SOL | 1665 | 1.8% | |
| INJ | 1639 | 1.8% | |
| LIQ | 1592 | 1.8% | |
| Other values (42) | 17653 | 19.5% | |
| (Missing) | 7785 | 8.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.031640392 |
| Min length | 2 |
| Distinct count | 52 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 7785 |
| Missing (%) | 8.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.18864604 |
|---|---|
| Minimum | 0.00483132632 |
| Maximum | 44.80330463 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0.00483132632 |
|---|---|
| 5-th percentile | 0.5556025268 |
| Q1 | 1.97963596 |
| median | 10.11558948 |
| Q3 | 44.80330463 |
| 95-th percentile | 44.80330463 |
| Maximum | 44.80330463 |
| Range | 44.7984733 |
| Interquartile range (IQR) | 42.82366867 |
Descriptive statistics
| Standard deviation | 20.55537735 |
|---|---|
| Coefficient of variation (CV) | 0.9263916918 |
| Kurtosis | -1.924535159 |
| Mean | 22.18864604 |
| Median Absolute Deviation (MAD) | 20.29462424 |
| Skewness | 0.1642905444 |
| Sum | 1834313.18 |
| Variance | 422.5235379 |
| Value | Count | Frequency (%) | |
| 44.80330463 | 37094 | 41.0% | |
| 10.11558948 | 8375 | 9.3% | |
| 5.946154868 | 4923 | 5.4% | |
| 3.786552003 | 3135 | 3.5% | |
| 3.098088003 | 2565 | 2.8% | |
| 2.477262571 | 2051 | 2.3% | |
| 2.387883034 | 1977 | 2.2% | |
| 2.160810697 | 1665 | 1.8% | |
| 1.97963596 | 1639 | 1.8% | |
| 1.922867875 | 1592 | 1.8% | |
| Other values (41) | 17653 | 19.5% | |
| (Missing) | 7785 | 8.6% |
| Value | Count | Frequency (%) | |
| 0.00483132632 | 4 | < 0.1% | |
| 0.0060391579 | 5 | < 0.1% | |
| 0.02174096844 | 18 | < 0.1% | |
| 0.03744277898 | 31 | < 0.1% | |
| 0.04589760004 | 76 | 0.1% |
| Value | Count | Frequency (%) | |
| 44.80330463 | 37094 | 41.0% | |
| 10.11558948 | 8375 | 9.3% | |
| 5.946154868 | 4923 | 5.4% | |
| 3.786552003 | 3135 | 3.5% | |
| 3.098088003 | 2565 | 2.8% |
| Distinct count | 3197 |
|---|---|
| Unique (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 10000005408 | 60 |
|---|---|
| 10000004918 | 60 |
| 10000006433 | 60 |
| 10000003498 | 60 |
| 10000005462 | 60 |
| Other values (3192) |
| Value | Count | Frequency (%) | |
| 10000005408 | 60 | 0.1% | |
| 10000004918 | 60 | 0.1% | |
| 10000006433 | 60 | 0.1% | |
| 10000003498 | 60 | 0.1% | |
| 10000005462 | 60 | 0.1% | |
| 10000005276 | 60 | 0.1% | |
| 10000006997 | 60 | 0.1% | |
| 10000006547 | 60 | 0.1% | |
| 10000003366 | 60 | 0.1% | |
| 10000005409 | 60 | 0.1% | |
| Other values (3187) | 89854 | 99.3% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 11 |
|---|---|
| Mean length | 11 |
| Min length | 11 |
source_boll
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 1 | |
|---|---|
| 0 | 554 |
| Value | Count | Frequency (%) | |
| 1 | 89900 | 99.4% | |
| 0 | 554 | 0.6% |
Sourcing_source
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| ארץ | |
|---|---|
| חו"ל | 554 |
| Value | Count | Frequency (%) | |
| ארץ | 89900 | 99.4% | |
| חו"ל | 554 | 0.6% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.00612466 |
| Min length | 3 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 90454 | 100.0% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
storecode
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 3224 | |
|---|---|
| 3315 |
| Value | Count | Frequency (%) | |
| 3224 | 45930 | 50.8% | |
| 3315 | 44524 | 49.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 7200 |
| Missing (%) | 8.0% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 1 | 333 |
| 3 | 55 |
| 2 | 15 |
| Value | Count | Frequency (%) | |
| 0 | 82851 | 91.6% | |
| 1 | 333 | 0.4% | |
| 3 | 55 | 0.1% | |
| 2 | 15 | < 0.1% | |
| (Missing) | 7200 | 8.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
TranQuantity
Real number (ℝ≥0)
| Distinct count | 1943 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.285248308 |
|---|---|
| Minimum | 0 |
| Maximum | 9.455714972 |
| Zeros | 447 |
| Zeros (%) | 0.5% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.6931471806 |
| Q1 | 1.386294361 |
| median | 3.044522438 |
| Q3 | 4.875197323 |
| 95-th percentile | 6.867974409 |
| Maximum | 9.455714972 |
| Range | 9.455714972 |
| Interquartile range (IQR) | 3.488902962 |
Descriptive statistics
| Standard deviation | 2.042987608 |
|---|---|
| Coefficient of variation (CV) | 0.6218670299 |
| Kurtosis | -0.8994655829 |
| Mean | 3.285248308 |
| Median Absolute Deviation (MAD) | 1.772242289 |
| Skewness | 0.4219250626 |
| Sum | 297163.8505 |
| Variance | 4.173798367 |
| Value | Count | Frequency (%) | |
| 0.6931471806 | 10724 | 11.9% | |
| 1.098612289 | 7477 | 8.3% | |
| 1.386294361 | 5285 | 5.8% | |
| 1.609437912 | 4096 | 4.5% | |
| 4.110873864 | 3589 | 4.0% | |
| 3.433987204 | 3294 | 3.6% | |
| 1.791759469 | 2928 | 3.2% | |
| 1.945910149 | 2473 | 2.7% | |
| 4.795790546 | 2067 | 2.3% | |
| 4.510859507 | 1843 | 2.0% | |
| Other values (1933) | 46678 | 51.6% |
| Value | Count | Frequency (%) | |
| 0 | 447 | 0.5% | |
| 0.6931471806 | 10724 | 11.9% | |
| 1.098612289 | 7477 | 8.3% | |
| 1.386294361 | 5285 | 5.8% | |
| 1.609437912 | 4096 | 4.5% |
| Value | Count | Frequency (%) | |
| 9.455714972 | 2 | < 0.1% | |
| 9.427143868 | 1 | < 0.1% | |
| 9.412546252 | 1 | < 0.1% | |
| 9.346705246 | 2 | < 0.1% | |
| 9.329455853 | 1 | < 0.1% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 85083 |
| Missing (%) | 94.1% |
| Memory size | 706.8 KiB |
| BOX | |
|---|---|
| TUB | |
| BOT | |
| PKG | 159 |
| BAG | 24 |
| Value | Count | Frequency (%) | |
| BOX | 3632 | 4.0% | |
| TUB | 773 | 0.9% | |
| BOT | 770 | 0.9% | |
| PKG | 159 | 0.2% | |
| BAG | 24 | < 0.1% | |
| KIT | 13 | < 0.1% | |
| (Missing) | 85083 | 94.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.940621752 |
| Min length | 3 |
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 88923 |
| Missing (%) | 98.3% |
| Memory size | 706.8 KiB |
| 01.03.2016 | 132 |
|---|---|
| 01.02.2018 | 117 |
| 01.10.2020 | 113 |
| 01.07.2018 | 107 |
| 01.10.2018 | 96 |
| Other values (27) |
| Value | Count | Frequency (%) | |
| 01.03.2016 | 132 | 0.1% | |
| 01.02.2018 | 117 | 0.1% | |
| 01.10.2020 | 113 | 0.1% | |
| 01.07.2018 | 107 | 0.1% | |
| 01.10.2018 | 96 | 0.1% | |
| 01.05.2020 | 86 | 0.1% | |
| 01.03.2017 | 81 | 0.1% | |
| 01.12.2019 | 71 | 0.1% | |
| 01.03.2020 | 66 | 0.1% | |
| 01.06.2018 | 65 | 0.1% | |
| Other values (22) | 597 | 0.7% | |
| (Missing) | 88923 | 98.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.101554381 |
| Min length | 4 |
| Distinct count | 83 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 85912 |
| Missing (%) | 95.0% |
| Memory size | 706.8 KiB |
| 28.02.2015 | 250 |
|---|---|
| 30.04.2015 | 247 |
| 30.11.2012 | 244 |
| 30.11.2013 | 181 |
| 31.01.2007 | 180 |
| Other values (77) |
| Value | Count | Frequency (%) | |
| 28.02.2015 | 250 | 0.3% | |
| 30.04.2015 | 247 | 0.3% | |
| 30.11.2012 | 244 | 0.3% | |
| 30.11.2013 | 181 | 0.2% | |
| 31.01.2007 | 180 | 0.2% | |
| 30.09.2012 | 142 | 0.2% | |
| 31.10.2013 | 120 | 0.1% | |
| 31.03.2015 | 119 | 0.1% | |
| 31.05.2014 | 113 | 0.1% | |
| 31.01.2008 | 113 | 0.1% | |
| Other values (72) | 2833 | 3.1% | |
| (Missing) | 85912 | 95.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.301280209 |
| Min length | 4 |
| Distinct count | 150 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 594 |
| Missing (%) | 0.7% |
| Memory size | 706.8 KiB |
| 400059 | 8701 |
|---|---|
| 400057 | 4983 |
| 408668 | 4824 |
| 400095 | 4199 |
| 400045 | 3597 |
| Other values (144) |
| Value | Count | Frequency (%) | |
| 400059 | 8701 | 9.6% | |
| 400057 | 4983 | 5.5% | |
| 408668 | 4824 | 5.3% | |
| 400095 | 4199 | 4.6% | |
| 400045 | 3597 | 4.0% | |
| 406885 | 3543 | 3.9% | |
| 407214 | 2828 | 3.1% | |
| 400026 | 2778 | 3.1% | |
| 410232 | 2705 | 3.0% | |
| 400032 | 2203 | 2.4% | |
| Other values (139) | 49499 | 54.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 5.986866252 |
| Min length | 4 |
VENDOR_Binary
Real number (ℝ≥0)
| Distinct count | 123 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 594 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.072614508 |
|---|---|
| Minimum | 0.00110984096 |
| Maximum | 9.656726191 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0.00110984096 |
|---|---|
| 5-th percentile | 0.1720253488 |
| Q1 | 1.002186387 |
| median | 2.348423471 |
| Q3 | 4.66022219 |
| 95-th percentile | 9.656726191 |
| Maximum | 9.656726191 |
| Range | 9.65561635 |
| Interquartile range (IQR) | 3.658035803 |
Descriptive statistics
| Standard deviation | 2.691063776 |
|---|---|
| Coefficient of variation (CV) | 0.8758221277 |
| Kurtosis | 0.7995755842 |
| Mean | 3.072614508 |
| Median Absolute Deviation (MAD) | 2.087136567 |
| Skewness | 1.230869029 |
| Sum | 276105.1397 |
| Variance | 7.241824246 |
| Value | Count | Frequency (%) | |
| 9.656726191 | 8701 | 9.6% | |
| 5.530337503 | 4983 | 5.5% | |
| 5.35387279 | 4824 | 5.3% | |
| 4.66022219 | 4199 | 4.6% | |
| 3.992097932 | 3597 | 4.0% | |
| 3.932166521 | 3543 | 3.9% | |
| 3.138630234 | 2828 | 3.1% | |
| 3.083138186 | 2778 | 3.1% | |
| 3.002119796 | 2705 | 3.0% | |
| 2.444979634 | 2203 | 2.4% | |
| Other values (112) | 49499 | 54.7% |
| Value | Count | Frequency (%) | |
| 0.00110984096 | 6 | < 0.1% | |
| 0.00221968192 | 6 | < 0.1% | |
| 0.003329522879 | 12 | < 0.1% | |
| 0.006659045759 | 18 | < 0.1% | |
| 0.007768886719 | 14 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9.656726191 | 8701 | 9.6% | |
| 5.530337503 | 4983 | 5.5% | |
| 5.35387279 | 4824 | 5.3% | |
| 4.66022219 | 4199 | 4.6% | |
| 3.992097932 | 3597 | 4.0% |
volume
Real number (ℝ≥0)
| Distinct count | 739 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.847270402 |
|---|---|
| Minimum | 0 |
| Maximum | 9.207736986 |
| Zeros | 127 |
| Zeros (%) | 0.1% |
| Memory size | 706.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.386294361 |
| Q1 | 1.945910149 |
| median | 4.418840608 |
| Q3 | 5.501258211 |
| 95-th percentile | 6.609349243 |
| Maximum | 9.207736986 |
| Range | 9.207736986 |
| Interquartile range (IQR) | 3.555348061 |
Descriptive statistics
| Standard deviation | 1.927719632 |
|---|---|
| Coefficient of variation (CV) | 0.501061644 |
| Kurtosis | -1.430752622 |
| Mean | 3.847270402 |
| Median Absolute Deviation (MAD) | 1.778535451 |
| Skewness | 0.0101202821 |
| Sum | 348000.9969 |
| Variance | 3.71610298 |
| Value | Count | Frequency (%) | |
| 1.386294361 | 7230 | 8.0% | |
| 1.609437912 | 5559 | 6.1% | |
| 1.791759469 | 4581 | 5.1% | |
| 1.945910149 | 4036 | 4.5% | |
| 2.079441542 | 3087 | 3.4% | |
| 1.098612289 | 3075 | 3.4% | |
| 2.302585093 | 2316 | 2.6% | |
| 2.197224577 | 2144 | 2.4% | |
| 2.397895273 | 1329 | 1.5% | |
| 2.48490665 | 1087 | 1.2% | |
| Other values (729) | 56010 | 61.9% |
| Value | Count | Frequency (%) | |
| 0 | 127 | 0.1% | |
| 0.6931471806 | 947 | 1.0% | |
| 1.098612289 | 3075 | 3.4% | |
| 1.386294361 | 7230 | 8.0% | |
| 1.609437912 | 5559 | 6.1% |
| Value | Count | Frequency (%) | |
| 9.207736986 | 2 | < 0.1% | |
| 9.019058794 | 11 | < 0.1% | |
| 8.42398081 | 60 | 0.1% | |
| 8.384347278 | 17 | < 0.1% | |
| 8.37262974 | 54 | 0.1% |
Volume_bool
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 57181 | 63.2% | |
| 1 | 33273 | 36.8% |
Volume_marker
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.8 KiB |
| LOW | |
|---|---|
| HIGH |
| Value | Count | Frequency (%) | |
| LOW | 57181 | 63.2% | |
| HIGH | 33273 | 36.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.367844429 |
| Min length | 3 |
First rows
| A | A_Budget | A_group_of_materials | A_group_of_materials_Binary | ABC | Affiliation_Group | Affiliation_Group_Binary | Alternative_purchasing_group | ATC | B | B_Budget | Basic_unit_of_measure | Budget_Group | C | Chemical_/_biological | chronic | Consumer_management | Consumer_management_Bool | consumption | consumption_previous_year | Current_consumption | Dangerous_material_is_charged_with_a_permit | dangerous_substance | Date_of_basket_entry | Description_Alternative_purchasing_group | Description_outline | Description_outline_Binary | df_index | E_Budget | EA | Establishment_date_of_the_item | European_patent_expires | Exceptional_policy | For_adults | Form_of_giving | General_purpose | General_purpose_ | GENERY_FATHER | Inventory | Inventory_of_consumption_months | Item_in_health_basket | Item_Type | Loading_group | Main_outline | Material_Type | Material_Type_bool | month_year | month_year_ | Must_prescribe | Narcotic_/_psychotropic | other_Budget | other_unit | PAC | Plant | Prediction | PRICE | Price_for_absolute_packaging | Pure_OTC | Quantity_in_absolute_packaging | Quantity_in_Packaging-Absolute | Quantity_in_packing-relative | Safety_Stock | Seasonality | Seasonality_bool | Send_code_to_Omri | Serving_form | Serving_form_Binary | skucode2 | source_boll | Sourcing_source | status | storecode | Toxic_item | TranQuantity | type_of_packeging | U#S#_Patent_Expires | Validity_of_Ministry_of_Health_registration | VENDOR | VENDOR_Binary | volume | Volume_bool | Volume_marker | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 20140 | 5.724555 | B | 15 | 5.802319 | 1180 | ATC:G03AA09 | 1 | 1 | PAC | B_Budget | 0 | 1 | 0 | ave | 1.0 | 8.759355 | 83062 | 8491 | None | None | 01.04.2005 | Oral contraceptive | Oral Contra. | 1.093001 | 0 | 0 | 0 | 2006-03-06 | None | 0 | None | 0 | 0 | 0 | None | 9.083870 | 1 | 1 | 0 | 23 | 171 | ZHW1 | 1 | 03/2017 | 03/2017 | 1 | 0 | 0 | 0 | 1 | 7350 | 8.902728 | 2.337952 | 5.286042 | 0 | 21 | 21 | 0 | 8.449343 | no | 1.0 | 1 | TAB | 44.803305 | 10000005719 | 1 | ארץ | 1 | 3224 | 0 | 2.484907 | BOX | None | None | 408668 | 5.353873 | 4.624973 | 0 | LOW |
| 1 | 0 | 0 | 20190 | 16.233172 | C | 20 | 16.017670 | 1054 | ATC:N06AA04 | 0 | 1 | EA | B_Budget | 1 | 1 | 1 | ave | 1.0 | 10.183049 | 306420 | 34920 | None | None | 01.01.1995 | Depression-Tricyclic | Antidepressants | 2.008209 | 1 | 0 | 1 | 2006-03-06 | None | 0 | None | 0 | 0 | 0 | 3999005422 | 11.135333 | 2 | 1 | 0 | 23 | 420 | ZHW1 | 1 | 02/2019 | 02/2019 | 1 | 0 | 0 | 0 | 0 | 7350 | 10.139073 | 0.190620 | 1.987874 | 0 | 30 | 30 | 0 | 10.342097 | no | 1.0 | 1 | TAB | 44.803305 | 10000006427 | 1 | ארץ | 1 | 3224 | 0 | 4.795791 | None | None | None | 400095 | 4.660222 | 1.386294 | 0 | LOW |
| 2 | 0 | 0 | 20270 | 4.767523 | C | 24 | 10.090558 | 1351 | ATC:D08AX08 | 0 | 0 | EA | E_Budget | 1 | 1 | 0 | ave | 1.0 | 7.186901 | 13544 | 2220 | 0 | 0 | None | חיטוי ידיים | cosmetics | 2.228957 | 2 | 1 | 1 | 2016-05-18 | None | 0 | None | None | 0 | 0 | None | 6.775366 | 0 | 0 | 0 | 23 | 392 | ZHW1 | 1 | 07/2017 | 07/2017 | 0 | NaN | 0 | 0 | 0 | 7350 | 7.116394 | 2.710713 | 2.710713 | 1 | 1 | 1 | 500 | 6.829794 | no | 1.0 | 1 | GEL | 2.477263 | 10000001880 | 1 | ארץ | 1 | 3315 | 0 | 1.098612 | None | None | None | 124207 | 2.412794 | 6.848005 | 1 | HIGH |
| 3 | 0 | 0 | 20180 | 4.087236 | C | 19 | 4.367753 | 1156 | ATC:M01AH01 | 0 | 1 | EA | B_Budget | 1 | 1 | 0 | ave | 1.0 | 10.759476 | 525410 | 59330 | None | None | None | NSAIDS-COX 2 inhibtors | Rheum. Arth. | 1.762404 | 4 | 0 | 1 | 2006-03-06 | None | 0 | None | 0 | 0 | 0 | 3999010655 | 11.378148 | 1 | 0 | 0 | 23 | 65 | ZHW1 | 1 | 02/2017 | 02/2017 | 1 | 0 | 0 | 0 | 0 | 7350 | 10.722695 | 0.444686 | 1.887070 | 0 | 10 | 10 | 0 | 10.894125 | no | 1.0 | 1 | CAP | 10.115589 | 10000006732 | 1 | ארץ | 1 | 3224 | 0 | 3.433987 | None | None | None | 400077 | 2.234110 | 2.397895 | 0 | LOW |
| 4 | 0 | 0 | 20120 | 10.418206 | B | 13 | 10.676974 | 1605 | ATC:C08CA01 | 1 | 1 | EA | B_Budget | 0 | 1 | 1 | ave | 1.0 | 0.000000 | 0 | 0 | None | None | 01.01.2000 | Calcium Chanell Blockers | Calcium Chanell Blockers | 0.406892 | 5 | 0 | 1 | 2006-09-26 | None | 0 | None | None | 0 | 0 | 3999019172 | 0.000000 | 0 | 1 | 0 | 23 | 431 | ZHW1 | 1 | 04/2017 | 04/2017 | 1 | 0 | 0 | 0 | 0 | 7350 | 0.000000 | 0.131028 | 1.335001 | 0 | 20 | 20 | 0 | 0.000000 | no | 1.0 | 1 | TAB | 44.803305 | 10000004522 | 1 | ארץ | 1 | 3315 | 0 | 8.077447 | None | None | None | 400059 | 9.656726 | 1.945910 | 1 | HIGH |
| 5 | 0 | 0 | 10150 | 2.248145 | C | 72 | 1.080066 | None | ZRP:102UB01 | 0 | 0 | EA | other_Budget | 1 | NaN | 1 | ave | 1.0 | 0.000000 | 0 | 0 | None | None | 01.03.2001 | None | None | NaN | 6 | 0 | 1 | 2009-06-03 | None | 0 | None | None | 0 | 0 | None | 0.000000 | 0 | 1 | 0 | 23 | None | ZHW3 | 0 | 03/2019 | 03/2019 | 1 | NaN | 1 | 0 | 0 | 7350 | 0.000000 | 3.521348 | 0.000000 | 0 | 0 | 0 | 0 | 0.000000 | no | 1.0 | 1 | None | NaN | 10000003897 | 1 | ארץ | 1 | 3315 | NaN | 1.609438 | None | None | None | 400044 | 2.350643 | 6.308098 | 1 | HIGH |
| 6 | 0 | 0 | 20220 | 4.189775 | C | 22 | 4.496963 | 1946 | ATC:S01XA30 | 0 | 0 | PAC | E_Budget | 1 | 1 | 0 | ave | 1.0 | 7.265430 | 17751 | 1852 | None | None | None | טיפות ליובש בעיניים | Artificial Tears | 1.085841 | 7 | 1 | 0 | 2010-12-27 | None | 0 | None | None | 0 | 0 | None | 7.990577 | 2 | 0 | 0 | 23 | 128 | ZHW1 | 1 | 05/2018 | 05/2018 | 0 | NaN | 0 | 0 | 1 | 7350 | 7.307202 | 3.286161 | 6.714995 | 1 | 32 | 32 | 0 | 7.342779 | no | 1.0 | 1 | COL | 3.786552 | 10000003478 | 1 | ארץ | 1 | 3315 | 0 | 2.397895 | None | None | None | 400006 | 1.080985 | 6.226537 | 0 | LOW |
| 7 | 0 | 0 | 20100 | 12.387400 | B | 11 | 12.762010 | 1354 | ATC:A01AB09 | 1 | 1 | EA | B_Budget | 0 | 1 | 0 | ave | 1.0 | 8.155075 | 39454 | 4049 | None | None | 01.01.1995 | טיפול אנטי פטרייתי | Fungal Inf, Oroph. | 0.120516 | 8 | 0 | 1 | 2006-03-06 | None | 0 | None | 0 | 0 | 0 | None | 7.828436 | 0 | 1 | 0 | 23 | 83 | ZHW1 | 1 | 01/2018 | 01/2018 | 0 | 0 | 0 | 0 | 0 | 7350 | 8.088255 | 2.643334 | 2.643334 | 0 | 1 | 1 | 40 | 7.462215 | no | 1.0 | 1 | GEL | 2.477263 | 10000006295 | 1 | ארץ | 1 | 3315 | 0 | 1.609438 | None | None | 30.04.2012 | 117469 | 0.536053 | 5.370638 | 0 | LOW |
| 8 | 0 | 0 | 10100 | 0.814801 | C | 24 | 10.090558 | 1429 | ZRP:A21AD | 0 | 0 | EA | E_Budget | 1 | NaN | 0 | ave | 1.0 | 6.244167 | 5821 | 712 | None | None | None | סד תמיכה ליד | None | NaN | 9 | 1 | 1 | 2006-03-06 | None | 0 | None | None | 0 | 0 | None | 7.156956 | 2 | 0 | 0 | 23 | None | ZHW3 | 0 | 05/2018 | 05/2018 | 0 | NaN | 0 | 0 | 0 | 7350 | 6.180017 | 3.409496 | 3.409496 | 1 | 1 | 1 | 0 | 6.410175 | no | 1.0 | 1 | None | NaN | 10000006992 | 1 | ארץ | 1 | 3224 | NaN | 1.098612 | None | None | None | 400123 | 0.836820 | 6.651572 | 0 | LOW |
| 9 | 0 | 0 | 20190 | 16.233172 | C | 20 | 16.017670 | 1017 | ATC:N07CA02 | 0 | 1 | EA | B_Budget | 1 | 1 | 1 | ave | 1.0 | 12.116930 | 2.15885e+06 | 223275 | None | None | 01.01.1995 | Antivertigo preparations | Meniere's Dis. | 0.213589 | 11 | 0 | 1 | 2006-03-06 | None | 0 | None | 0 | 0 | 0 | None | 12.540135 | 1 | 1 | 0 | 23 | 209 | ZHW1 | 1 | 06/2017 | 06/2017 | 1 | 0 | 0 | 0 | 0 | 7350 | 12.086264 | 0.182322 | 1.791759 | 0 | 25 | 25 | 0 | 11.760254 | no | 1.0 | 1 | TAB | 44.803305 | 10000006644 | 1 | ארץ | 1 | 3224 | 0 | 6.356108 | None | None | 30.09.2012 | 401974 | 1.215276 | 2.079442 | 1 | HIGH |
Last rows
| A | A_Budget | A_group_of_materials | A_group_of_materials_Binary | ABC | Affiliation_Group | Affiliation_Group_Binary | Alternative_purchasing_group | ATC | B | B_Budget | Basic_unit_of_measure | Budget_Group | C | Chemical_/_biological | chronic | Consumer_management | Consumer_management_Bool | consumption | consumption_previous_year | Current_consumption | Dangerous_material_is_charged_with_a_permit | dangerous_substance | Date_of_basket_entry | Description_Alternative_purchasing_group | Description_outline | Description_outline_Binary | df_index | E_Budget | EA | Establishment_date_of_the_item | European_patent_expires | Exceptional_policy | For_adults | Form_of_giving | General_purpose | General_purpose_ | GENERY_FATHER | Inventory | Inventory_of_consumption_months | Item_in_health_basket | Item_Type | Loading_group | Main_outline | Material_Type | Material_Type_bool | month_year | month_year_ | Must_prescribe | Narcotic_/_psychotropic | other_Budget | other_unit | PAC | Plant | Prediction | PRICE | Price_for_absolute_packaging | Pure_OTC | Quantity_in_absolute_packaging | Quantity_in_Packaging-Absolute | Quantity_in_packing-relative | Safety_Stock | Seasonality | Seasonality_bool | Send_code_to_Omri | Serving_form | Serving_form_Binary | skucode2 | source_boll | Sourcing_source | status | storecode | Toxic_item | TranQuantity | type_of_packeging | U#S#_Patent_Expires | Validity_of_Ministry_of_Health_registration | VENDOR | VENDOR_Binary | volume | Volume_bool | Volume_marker | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90444 | 0 | 0 | 20130 | 8.538320 | C | 14 | 8.845941 | 1517 | ATC:D08AX01 | 0 | 1 | EA | B_Budget | 1 | 1 | NaN | ave | 1.0 | 7.830028 | 28150 | 3399 | None | None | 01.01.1995 | תכשיר לחיטוי | Antiseptic | 0.943847 | 109189 | 0 | 1 | 2014-08-24 | None | 0 | None | None | 0 | 0 | None | 8.134468 | 1 | 1 | 0 | 23 | 135 | ZHW1 | 1 | 02/2017 | 02/2017 | NaN | NaN | 0 | 0 | 0 | 7350 | 7.789455 | 1.453953 | 1.453953 | 0 | 1 | 1 | 100 | 7.473637 | no | 1.0 | 1 | SOL | 2.160811 | 10000002477 | 1 | ארץ | 1 | 3315 | 0 | 1.098612 | None | None | None | 400171 | 1.703606 | 5.894403 | 1 | HIGH |
| 90445 | 0 | 0 | 20130 | 8.538320 | C | 14 | 8.845941 | 1519 | ATC:D02AC02 | 0 | 0 | EA | E_Budget | 1 | 1 | 0 | pred | 0.0 | 6.803505 | 9426 | 1085 | None | None | None | תכשיר רחצה טיפולי - תינוקות | Dry Skin | 1.450970 | 109190 | 1 | 1 | 2010-06-09 | None | 0 | None | None | 0 | 0 | None | 7.355002 | 1 | 0 | 0 | 25 | 142 | ZHW1 | 1 | 06/2018 | 06/2018 | 0 | NaN | 0 | 0 | 0 | 7350 | 6.858565 | 3.438493 | 3.438493 | 1 | 1 | 1 | 500 | 6.634633 | yes | 0.0 | 1 | OIL | 0.359934 | 10000003622 | 1 | ארץ | 1 | 3315 | 0 | 1.098612 | None | None | None | 400044 | 2.350643 | 6.893656 | 1 | HIGH |
| 90446 | 1 | 0 | 20160 | 3.215101 | A | 17 | 3.190502 | 1651 | ATC:J07AJ52 | 0 | 1 | EA | B_Budget | 0 | 2 | 0 | pred | 0.0 | 0.000000 | 0 | 0 | None | None | None | DPT Vac. | DPT Vac. | 0.003580 | 109191 | 0 | 1 | 2011-03-22 | None | 1 | None | None | 0 | 0 | 3999002140 | 0.000000 | 0 | 1 | 0 | 11 | 96 | ZHW1 | 1 | 01/2017 | 01/2017 | 1 | NaN | 0 | 0 | 0 | 7350 | 0.000000 | 4.161692 | 4.161692 | 0 | 1 | 1 | 0 | 0.000000 | no | 1.0 | 1 | SRG | 0.843066 | 10000003406 | 1 | ארץ | 1 | 3315 | 0 | 0.000000 | None | None | None | 400164 | 0.003330 | 5.075174 | 0 | LOW |
| 90447 | 0 | 0 | 20240 | 1.068393 | B | 24 | 10.090558 | 1401 | ATC:V06DB15 | 1 | 1 | EA | B_Budget | 0 | 1 | 0 | ave | 1.0 | 9.615872 | 196110 | 19770 | None | None | 01.03.2008 | מזון ייעודי | Metab. Disord. | 0.050116 | 109192 | 0 | 1 | 2014-11-04 | None | 0 | None | None | 0 | 0 | None | 9.292934 | 0 | 1 | 0 | 25 | 107 | ZHW1 | 1 | 04/2019 | 04/2019 | 0 | NaN | 0 | 0 | 0 | 7350 | 9.701127 | 2.303585 | 2.303585 | 1 | 1 | 1 | 220 | 9.095715 | no | 1.0 | 1 | LIQ | 1.922868 | 10000002408 | 1 | ארץ | 1 | 3315 | 0 | 4.110874 | None | None | None | 401882 | 0.924498 | 6.144186 | 1 | HIGH |
| 90448 | 0 | 0 | 20180 | 4.087236 | B | 19 | 4.367753 | 1076 | ATC:M04AC01 | 1 | 1 | EA | B_Budget | 0 | 1 | 1 | ave | 1.0 | 13.046046 | 5.31108e+06 | 619170 | None | None | 01.01.1995 | FMF | Gout | 0.218361 | 109193 | 0 | 1 | 2006-03-06 | None | 0 | None | 0 | 0 | 0 | None | 12.731011 | 0 | 1 | 0 | 23 | 75 | ZHW1 | 1 | 01/2017 | 01/2017 | 1 | 5 | 0 | 0 | 0 | 7350 | 13.019404 | 0.300105 | 2.442347 | 0 | 30 | 30 | 0 | 12.352901 | no | 1.0 | 1 | TAB | 44.803305 | 10000006474 | 1 | ארץ | 1 | 3224 | 0 | 7.170888 | None | None | None | 400045 | 3.992098 | 1.098612 | 1 | HIGH |
| 90449 | 0 | 0 | 20190 | 16.233172 | C | 20 | 16.017670 | 1823 | ATC:N02AA05 | 0 | 1 | EA | B_Budget | 1 | 1 | 0 | ave | 1.0 | 6.542472 | 8445 | 861 | None | None | None | Pain, Mod/Sev | Pain, Mod/Sev | 1.773143 | 109195 | 0 | 1 | 2013-10-14 | None | 0 | None | None | 0 | 0 | None | 6.700731 | 1 | 0 | 0 | 13 | 59 | ZHW1 | 1 | 03/2018 | 03/2018 | 1 | 1 | 0 | 0 | 0 | 7350 | 6.595781 | 3.519277 | 3.519277 | 0 | 1 | 1 | 30 | 6.658011 | no | 1.0 | 1 | SYR | 1.322576 | 10000002704 | 1 | ארץ | 1 | 3315 | 0 | 1.609438 | None | None | None | 400045 | 3.992098 | 5.129899 | 0 | LOW |
| 90450 | 0 | 0 | 20130 | 8.538320 | C | 14 | 8.845941 | 1352 | ATC:D08AG02 | 0 | 1 | EA | B_Budget | 1 | 1 | 0 | pred | 0.0 | 8.718173 | 74934 | 6830 | None | None | 01.01.1995 | חיטוי נגעים בעור | Antiseptic | 0.943847 | 109196 | 0 | 1 | 2006-03-06 | None | 0 | None | 0 | 0 | 0 | 3999021150 | 8.567696 | 0 | 1 | 0 | 23 | 135 | ZHW1 | 1 | 03/2018 | 03/2018 | 0 | 0 | 0 | 0 | 0 | 7350 | 8.502080 | 1.506297 | 1.506297 | 0 | 1 | 1 | 15 | 8.145550 | yes | 0.0 | 1 | OIN | 2.387883 | 10000006784 | 1 | ארץ | 1 | 3315 | 0 | 2.995732 | None | None | None | 400057 | 5.530338 | 4.934474 | 1 | HIGH |
| 90451 | 0 | 0 | 20100 | 12.387400 | C | 11 | 12.762010 | 1375 | ATC:A07BB01 | 0 | 1 | EA | B_Budget | 1 | 1 | 0 | ave | 1.0 | 11.155879 | 637500 | 116040 | None | None | 01.01.1995 | טיפול בשלשול וכאב בטן | Diarrhea | 0.742190 | 109197 | 0 | 1 | 2013-07-01 | None | 0 | None | None | 0 | 0 | 3999002540 | 11.512535 | 1 | 1 | 0 | 23 | 47 | ZHW1 | 1 | 06/2019 | 06/2019 | 0 | NaN | 0 | 0 | 0 | 7350 | 10.886820 | 0.254642 | 1.916923 | 0 | 20 | 20 | 0 | 11.313840 | no | 1.0 | 1 | TAB | 44.803305 | 10000002793 | 1 | ארץ | 1 | 3315 | 0 | 5.484797 | None | None | None | 400026 | 3.083138 | 1.945910 | 0 | LOW |
| 90452 | 0 | 0 | 20150 | 1.523755 | C | 16 | 1.526229 | 1694 | ATC:H02AB07 | 0 | 1 | EA | B_Budget | 1 | 1 | 1 | ave | 1.0 | 12.040024 | 1.913e+06 | 221300 | None | None | 01.01.1995 | Glucocorticoid | Glucocorticoid | 0.509510 | 109198 | 0 | 1 | 2006-03-06 | None | 0 | None | 0 | 0 | 0 | None | 12.220473 | 1 | 1 | 0 | 23 | 141 | ZHW1 | 1 | 09/2017 | 09/2017 | 1 | 0 | 0 | 0 | 0 | 7350 | 11.995882 | 0.139762 | 2.772589 | 0 | 100 | 100 | 0 | 12.104544 | no | 1.0 | 1 | TAB | 44.803305 | 10000006612 | 1 | ארץ | 1 | 3224 | 0 | 5.707110 | None | None | None | 400057 | 5.530338 | 0.000000 | 0 | LOW |
| 90453 | 0 | 1 | 20220 | 4.189775 | B | 22 | 4.496963 | 1082 | ATC:S01EA05 | 1 | 0 | EA | A_Budget | 0 | 1 | 1 | ave | 1.0 | 9.131622 | 108414 | 12071 | None | None | 01.10.2005 | Glaucoma alpha 2 agonist | Glaucoma | 1.468869 | 109199 | 0 | 1 | 2006-03-06 | None | 0 | None | 0 | 0 | 0 | 3999001444 | 8.757784 | 0 | 1 | 0 | 23 | 15 | ZHW1 | 1 | 09/2019 | 09/2019 | 1 | 0 | 0 | 0 | 0 | 7350 | 9.080687 | 2.855320 | 2.855320 | 0 | 1 | 1 | 5 | 8.438583 | no | 1.0 | 1 | COL | 3.786552 | 10000005869 | 1 | ארץ | 1 | 3315 | 0 | 3.713572 | None | None | None | 400036 | 0.842369 | 4.418841 | 0 | LOW |